{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["калькуляция блюда","меню","потребность","Лист1"],"read":"whole","date_system":"1900"}

{"sheet":"калькуляция блюда","index":0,"n_rows":39,"n_cols":33,"rows_kept":39,"merged":[[0,0,0,24],[38,0,38,1]]}
["КАЛЬКУЛЯЦИЯ БЛЮД"]
["наименование","цена","Горбуша тушенная с овощами","хлеб в/с","хлеб дарницкий","чай с сахаром","салат из моркови с сахаром","котлеты рубленные из говядины","гуляш из говядины","каша гречневая рассыпчатая","чай с лимоном","кофейный напиток","банан","гуляш из птицы","груша","рис отварной","макароны       отварные","котлеты рубленные из птицы","картофельное       пюре","какао с молоком","плов из птицы","салат из свеклы отварной","пельмени отварные","салат из свежей капусты","жаркое из птицы","каша молочная манная","булочка","тефтели мясные с рисом","сок фруктово-ягодный ","яблоко","апельсины","сыр","огурец"]
["лимон",70,{"$nulls":8},0.008]
["грудка ",319.89,{"$nulls":11},0.107,{"$nulls":3},0.09,null,null,0.09,{"$nulls":3},0.096]
["какао",177.04,{"$nulls":17},0.004]
["капуста",12,{"$nulls":21},0.068]
["картофель   ",16.76,{"$nulls":16},0.171,{"$nulls":5},0.106]
["кофейный напиток",151,{"$nulls":9},0.005]
["банан",{"$nulls":11},0.15]
["гречка ",104.01,{"$nulls":7},0.035]
["манка ",49.87,{"$nulls":23},0.03]
["груша",80,{"$nulls":12},0.12]
["макароны ",41.8,{"$nulls":14},0.05]
["лук",20,0.014,{"$nulls":4},0.01,0.018,{"$nulls":4},0.018,{"$nulls":6},0.011,{"$nulls":3},0.012,null,null,0.013]
["горбуша или треска",227.22,0.123]
["масло раст ",92.37,0.007,{"$nulls":4},0.003,0.005,{"$nulls":4},0.005,{"$nulls":6},0.005,2E-3,null,0.003,0.004,null,null,2E-3]
["масло сливочное",558.97,{"$nulls":7},0.005,{"$nulls":5},0.005,0.005,0.003,0.005,{"$nulls":3},0.005,null,null,0.005]
["морковь",17,0.032,{"$nulls":3},0.073,{"$nulls":13},0.016,null,null,0.013]
["мука",37.5,{"$nulls":6},0.004,{"$nulls":4},0.004]
["мясо",378.05,{"$nulls":5},0.1,0.107,{"$nulls":18},0.052]
["пельмени",260,{"$nulls":20},0.16]
["рис",78.8,{"$nulls":13},0.054,{"$nulls":4},0.057,{"$nulls":6},0.005]
["сахар",67.6,{"$nulls":3},0.015,1E-3,{"$nulls":3},0.015,0.02,{"$nulls":7},0.02,{"$nulls":3},2E-3,null,0.003]
["рыба минтай",128.84]
["свекла",16,{"$nulls":19},0.073]
["молоко",60.98,{"$nulls":5},0.024,{"$nulls":3},0.1,{"$nulls":5},0.018,0.023,0.1,{"$nulls":5},0.1]
["булочка (50гр)",8.92,{"$nulls":24},1]
["соль",15.5,1E-3,{"$nulls":4},1E-3,2E-3,1E-3,{"$nulls":3},1E-3,null,1E-3,1E-3,1E-3,1E-3,null,1E-3,null,1E-3,1E-3,1E-3,1E-3,null,1E-3]
["яблоки  свежие",69.15,{"$nulls":27},0.15]
["сыр ",580.79,{"$nulls":29},0.0209]
["хлеб дарницкий(кг)",55.12,null,null,0.025]
["томат паста",111.9,{"$nulls":6},0.012,{"$nulls":4},0.012,{"$nulls":6},0.005]
["сок(1 литр)",64.9,{"$nulls":26},0.2]
["хлеб в/с(кг)",67.01,null,0.05]
["чай  ",463.95,{"$nulls":3},1E-3,{"$nulls":4},2E-3]
["апельсины",70,{"$nulls":28},0.15]
["помидор",0]
["огурец",0,{"$nulls":30},0.063]
["стоимость блюда",null,{"$f":"B14*C14+B15*C15+B16*C16+B18*C18+B28*C28","v":{"v":29.43415,"d":"29.43"}},{"$f":"D34*B34","v":{"v":3.3505000000000003,"d":"3.35"}},{"$f":"B31*E31","v":{"v":1.3780000000000001,"d":"1.38"}},{"$f":"F23*B23+F35*B35","v":{"v":1.4779499999999999,"d":"1.48"}},{"$f":"G18*B18+G23*B23","v":{"v":1.3085999999999998,"d":"1.31"}},{"$f":"B14*H14+B16*H16+B20*H20+B26*H26+B28*H28","v":{"v":39.76113000000001,"d":"39.76"}},{"$f":"I14*B14+I16*B16+I18*B18+I19*B19+I20*B20+I28*B28+I32*B32","v":{"v":42.797,"d":"42.80"}},{"$f":"J10*B10+J17*B17+J28*B28","v":{"v":6.450700000000001,"d":"6.45"}},{"$f":"B3*K3+B23*K23+B35*K35","v":{"v":2.5019,"d":"2.50"}},{"$f":"B8*L8+B23*L23+B26*L26","v":{"v":8.205,"d":"8.21"}},{"$f":"B9*M9","v":{"v":0,"d":"0.00"}},{"$f":"B4*N4+B14*N14+B16*N16+B19*N19+B28*N28+B32*N32","v":{"v":36.55837999999999,"d":"36.56"}},{"$f":"B12*O12","v":{"v":9.6,"d":"9.60"}},{"$f":"P17*B17+P22*B22+P28*B28","v":{"v":7.06555,"d":"7.07"}},{"$f":"Q13*B13+Q17*B17+Q28*B28","v":{"v":4.90035,"d":"4.90"}},{"$f":"R4*B4+R17*B17+R26*B26+R28*B28","v":{"v":31.580149999999996,"d":"31.58"}},{"$f":"S7*B7+S17*B17+S26*B26+S28*B28","v":{"v":7.078850000000001,"d":"7.08"}},{"$f":"T23*B23+T26*B26+T5*B5","v":{"v":8.158159999999999,"d":"8.16"}},{"$f":"U4*B4+U14*B14+U16*B16+U18*B18+U22*B22+U32*B32+U28*B28","v":{"v":34.81055,"d":"34.81"}},{"$f":"V16*B16+V25*B25","v":{"v":1.3527399999999998,"d":"1.35"}},{"$f":"W17*B17+W21*B21+W28*B28","v":{"v":44.41035000000001,"d":"44.41"}},{"$f":"X6*B6+X16*B16+X23*B23+X28*B28","v":{"v":1.24381,"d":"1.24"}},{"$f":"Y4*B4+Y7*B7+Y14*B14+Y16*B16*Y28*B28","v":{"v":32.73172694000001,"d":"32.73"}},{"$f":"Z11*B11+Z17*B17+Z23*B23+Z26*B26+Z28*B28","v":{"v":10.60725,"d":"10.61"}},{"$f":"AA27*B27","v":8.92},{"$f":"AB14*B14+AB16*B16+AB20*B20+AB22*B22+AB28*B28","v":{"v":20.512839999999997,"d":"20.51"}},{"$f":"AC33*B33","v":12.980000000000002},{"$f":"AD29*B29","v":{"v":10.3725,"d":"10.37"}},{"$f":"AE36*B36","v":10.5},{"$f":"B30*AF30","v":{"v":12.138510999999998,"d":"12.14"}},{"$f":"B38*AG38","v":0}]

{"sheet":"меню","index":1,"n_rows":123,"n_cols":12,"rows_kept":123,"merged":[[1,7,1,12],[4,0,4,11],[5,0,5,11],[6,0,8,0],[6,1,8,1],[6,3,8,3],[6,4,6,6],[6,7,8,7],[6,8,6,9],[6,11,8,11],[7,4,8,4],[7,5,8,5],[7,6,8,6],[7,8,8,8],[7,9,8,9],[7,10,8,10],[9,0,9,11],[10,0,17,0],[19,0,19,11],[20,0,25,0],[27,0,27,11],[28,0,35,0],[37,0,37,11],[38,0,45,0],[47,0,47,11],[48,0,55,0],[57,0,57,11],[58,0,60,0],[63,0,63,1],[64,0,71,0],[73,0,73,11],[74,0,74,11],[75,0,81,0],[83,0,83,11],[84,0,90,0],[92,0,92,11],[93,0,100,0],[102,0,102,11],[103,0,109,0],[111,0,111,11],[112,0,115,0],[119,0,123,0]]}
[{"$nulls":8},"Утверждаю"]
[{"$nulls":7},"Руководитель отдела образования"]
[{"$nulls":7},"Сармановского МР РТ"]
[{"$nulls":7},"______________Идрисова Г.Я."]
["ПРИМЕРНОЕ 12 ДНЕВНОЕ МЕНЮ (горячий завтрак) ДЛЯ   обучающихся 1-4 класов школ Сармановского муниципального района"]
["на 1 полугодие 2022-2023 учебного года "]
[null,"Наименование блюда",null,"Выход блюда   (гр)","Пищевые вещества(г)",null,null,"Энергетическая ценность (ккал)","Минеральные вещества (мг)",null,"Витамин(мг)","№ тех. карты"]
[null,null,"Примерная стоимость блюда (руб)",null,"Б","Ж","У",null,"Са","Р","С"]
[]
["     1 неделя - понедельник"]
["горячий завтрак","Салат из моркови с сахаром",1.31,60,1.08,0.18,8.62,40.4,24.28,44,6.25,"ТТК 38"]
[null,"Котлеты рубленные из говядины",39.76,100,16.5,24.2,14.32,344,32.36,41.84,0.26," ТТК  268"]
[null,"Каша гречневая рассыпчатая с маслом",6.45,150,8.6,6.09,38.64,243.75,14.82,220.3,0,"ТТК 302"]
[null,"Чай с лимоном",2.5,200,0.13,0.02,15.2,62,14.2,22,2.83,"ТТК 377"]
[null,"Хлеб пшеничный в/с",3.35,50,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Хлеб дарницкий",1.38,25,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Фрукты (яблоко свежее)",10.37,150,0.6,0.6,14.7,70.3,24,13.5,15,"ТТК 338"]
[]
[null,"ИТОГО",{"$f":"SUM(C11:C18)","v":65.12},null,{"$f":"SUM(E11:E17)","v":32.349999999999994},32.06999999999999,92.46,909.65,138.52,380.64,24.34]
["       1 неделя -  вторник"]
["горячий завтрак","Жаркое из птицы",32.73,"50/100",17.21,4.67,13.72,165.63,19.44,210.63,5.61,"ТТК 436"]
[null,"Какао с молоком",8.16,200,4.08,3.54,17.58,118.6,152.22,90,1.59,"ТТК382"]
[null,"Хлеб пшеничный в/с",3.35,50,2.72,0.19,0.19,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Хлеб дарницкий",1.38,25,2.72,0.19,0.19,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Фрукты (груша свежая)",9.6,120,0.6,0.46,14.7,68.26,17.5,17.3,7.5,"ТТК 338"]
[]
[null,"ИТОГО",{"$f":"SUM(C21:C26)","v":55.220000000000006},null,27.33,9.05,46.379999999999995,501.69000000000005,218.02,356.93,14.7]
["       1 неделя  -среда"]
["горячий завтрак","Салат из свеклы отварной",1.35,60,0.86,3.65,5.02,56.34,21.09,24.58,5.7,"ТТК 33"]
[null,"Гуляш из говядины ",42.13,"50/75",14.55,16.79,2.89,221,21.81,154,0.92,"ТТК 260"]
[null,"Макароны отварные",4.9,150,5.46,5.79,30.45,195.7,12.14,7.5,0,"ТТК 202"]
[null,"Чай с сахаром",1.48,"200/15",0.07,0.02,15,60,11.1,7.5,0.03,"ТТК 376"]
[null,"Хлеб пшеничный в/с",3.35,55,2.72,0.19,0.19,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Хлеб дарницкий",1.38,25,2.72,0.19,0.19,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Фрукты (яблоко свежее)",10.37,150,0.6,0.6,14.7,70.3,24,13.5,15,"ТТК 338"]
[]
[null,"ИТОГО",{"$f":"SUM(C29:C36)","v":64.96000000000001},null,{"$f":"SUM(E29:E36)","v":26.98},27.23,68.44,752.54,119,246.07999999999998,21.65]
["         1 неделя  - четверг "]
["горячий завтрак","Салат из свежей капусты ",1.24,60,0.86,3.65,5.02,56.34,21.09,24.58,5.7,"ТТК 43"]
[null,"Котлета рубленная из птицы ",31.58,90,14.6,14.8,11.5,236.3,56,105.9,0.26,"ТТК 307"]
[null,"Пюре картофельное",7.08,150,3.06,4.8,20.45,137.25,36.98,86.6,18.17,"ТТК 694"]
[null,"Чай с лимоном",2.5,200,0.13,0.02,15.2,62,14.2,22,2.83,"ТТК 377"]
[null,"Хлеб пшеничный в/с",3.35,50,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Хлеб дарницкий",1.38,25,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Фрукты (апельсин свежий)",10.5,150,0.3,1.35,12.15,64.5,0.72,0,144,"ТТК 907"]
[]
[null,"ИТОГО",{"$f":"SUM(C39:C46)","v":57.63},null,24.389999999999997,25.599999999999998,65.30000000000001,705.59,157.85,278.08000000000004,170.96]
["        1 неделя - пятница "]
["горячий завтрак","Горбуша тушеная с овощами",29.43,90,7.75,3.95,2.8,125,39.07,56.3,3.73," ТТК 229"]
[null,"Рис отварной ",7.07,150,3.65,5.37,36.68,209.7,2.4,34.2,0,"ТТК 304"]
[null,"Чай с сахаром",1.48,"200/15",0.07,0.02,15,60,11.1,7.5,0.03,"ТТК 376"]
[null,"Хлеб пшеничный в/с",3.35,50,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Хлеб дарницкий",1.38,25,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Фрукты (яблоко свежее)",10.37,150,0.6,0.6,14.7,70.3,24,13.5,15,"ТТК 338"]
[]
[]
[null,"ИТОГО",{"$f":"SUM(C49:C56)","v":53.08},null,{"$f":"SUM(E49:E56)","v":17.51},10.92,70.16,614.1999999999999,105.43,150.5,18.759999999999998]
["        1 неделя -суббота"]
["горячий завтрак","Пельмени отварные ",44.41,"180/5",10.34,12.18,20.34,237,11.8,237.4,0.491,"ТТК 168"]
[null,"Чай с лимоном",2.5,200,0.13,0.02,15.2,62,14.2,22,2.83,"ТТК 377"]
[null,"Хлеб пшеничный в/с",3.35,50,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Сок  фруктово-ягодный",13,200,1,0,20.2,84.4,14,10,4,"ТТК 389"]
[null,"ИТОГО",{"$f":"SUM(C59:C62)","v":63.26},null,{"$f":"SUM(E59:E61)","v":13.190000000000001},12.69,36.03,373.6,40.43,278.9,3.321]
["        2 неделя - понедельник"]
["горячий завтрак","Салат из свежей капусты ",1.24,60,0.86,3.65,5.02,56.34,21.09,24.58,5.7,"ТТК 43"]
[null,"Тефтели мясные с рисом",20.51,55,7.58,7.84,7.95,125.36,14.88,15.89,0.44,"ТТК 287"]
[null,"Каша гречневая рассыпчатая с маслом",6.45,150,8.6,6.09,38.64,243.75,14.82,220.3,0,"ТТК 302"]
[null,"Чай с сахаром",1.48,"200/15",0.07,0.02,15,60,11.1,7.5,0.03,"ТТК 376"]
[null,"Хлеб пшеничный в/с",3.35,50,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Хлеб дарницкий",1.38,25,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Фрукты (груша свежая)",9.6,120,0.6,0.46,14.7,68.26,17.5,17.3,7.5,"ТТК 338"]
[]
[null,"ИТОГО",{"$f":"SUM(C65:C72)","v":44.010000000000005},null,23.15,19.039999999999996,82.28999999999999,702.91,108.25,324.57,13.670000000000002]
[]
["       2 неделя - вторник  "]
["горячий завтрак","Салат из свеклы отварной",1.35,60,0.86,3.65,5.02,56.34,21.09,24.58,5.7,"ТТК 33"]
[null,"Плов из птицы",34.53,"50/150",14,19,42,377,22,204,0.62,"ТТК 304"]
[null,"Кофейный напиток",8.21,200,3.17,2.68,15.9,100.6,125.78,14,1.3,"ТТК 379"]
[null,"Хлеб пшеничный в/с",3.35,50,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Хлеб дарницкий",1.38,25,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Фрукты (апельсин свежий)",10.5,150,0.3,1.35,12.15,64.5,0.72,0,144,"ТТК 907"]
[]
[null,"ИТОГО",{"$f":"SUM(C76:C82)","v":59.32000000000001},null,{"$f":"SUM(E76:E82)","v":23.77},27.659999999999997,76.05,747.6400000000001,198.45000000000002,281.58,151.62]
["    2 неделя - среда "]
["горячий завтрак","Горбуша тушеная с овощами",29.43,90,7.75,3.95,2.8,125,39.07,56.3,3.73," ТТК 229"]
[null,"Пюре картофельное",7.08,150,3.06,4.8,20.45,137.25,36.98,86.6,18.17,"ТТК 694"]
[null,"Чай с лимоном",2.5,200,0.13,0.02,15.2,62,14.2,22,2.83,"ТТК 377"]
[null,"Хлеб пшеничный в/с",3.35,50,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Хлеб дарницкий",1.38,25,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Сок  фруктово-ягодный",13,200,1,0,20.2,84.4,14,10,4,"ТТК 389"]
[]
[null,"ИТОГО",{"$f":"SUM(C85:C91)","v":56.74},null,{"$f":"SUM(E85:E91)","v":17.380000000000003},9.75,59.63000000000001,557.85,133.11,213.89999999999998,28.730000000000004]
["      2 неделя - четверг "]
["горячий завтрак","Салат из моркови с сахаром",1.31,60,1.08,0.18,8.62,40.4,24.28,44,6.25,"ТТК 38"]
[null,"Котлета рубленная из птицы ",31.58,90,14.6,14.8,11.5,236.3,56,105.9,0.26,"ТТК 307"]
[null,"Макароны отварные",4.9,150,5.46,5.79,30.45,195.7,12.14,7.5,0,"ТТК 202"]
[null,"Какао с молоком",8.16,200,4.08,3.54,17.58,118.6,152.22,90,1.59,"ТТК382"]
[null,"Хлеб пшеничный в/с",3.35,50,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Хлеб дарницкий",1.38,25,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Фрукты (яблоко свежее)",10.37,150,0.6,0.6,14.7,70.3,24,13.5,15,"ТТК 338"]
[]
[null,"ИТОГО",{"$f":"SUM(C94:C101)","v":61.050000000000004},null,31.259999999999998,25.889999999999997,83.82999999999998,810.5,297.5,299.9,23.1]
["     2 неделя - пятница"]
["горячий завтрак","Гуляш из птицы",35.89,"50/50",12.11,10.76,2.39,164,85.18,163.193,6.32,"ТТК 437"]
[null,"Рис отварной ",7.07,150,3.65,5.37,36.68,209.7,2.4,34.2,0,"ТТК 304"]
[null,"Чай с сахаром",1.48,"200/15",0.07,0.02,15,60,11.1,7.5,0.03,"ТТК 376"]
[null,"Хлеб пшеничный в/с",3.35,50,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Хлеб дарницкий",1.38,25,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"Сок  фруктово-ягодный",13,200,1,0,20.2,84.4,14,10,4,"ТТК 389"]
[]
[null,"ИТОГО",{"$f":"SUM(C104:C110)","v":62.17},null,22.27,17.129999999999995,75.25,667.3,141.54000000000002,253.89300000000003,10.350000000000001]
["      2 неделя  - суббота "]
["горячий завтрак","Каша молочная манная",10.61,"200/5",6.11,10.72,32.38,251,133.77,67,1.17,"ТТК 181"]
[null,"Сыр порционный",12.14,20,5.2,5.36,0,70.4,208,0,0.56,"ТТК 29"]
[null,"Чай с лимоном",2.5,200,0.13,0.02,15.2,62,14.2,22,2.83,"ТТК 377"]
[null,"Булочка сдобная",8.92,50,4.2,7.06,32.064,209.33,9.22,37.22,0,"ТТК 34"]
[null,"Фрукты (апельсин свежий)",10.5,150,0.3,1.35,12.15,64.5,0.72,0,144,"ТТК 907"]
[null,"Хлеб дарницкий",1.38,25,2.72,0.49,0.49,74.6,14.43,19.5,0,"ТТК 61"]
[null,"ИТОГО ",{"$f":"SUM(C113:C118)","v":46.050000000000004},null,{"$f":"SUM(E113:E116)","v":15.64},23.16,79.644,592.73,365.19,126.22,4.5600000000000005]
[]
[null,"ИТОГО за 12 дней",{"$f":"C19+C27+C37+C47+C57+C63+C73+C83+C92+C102+C111+C119","v":688.6099999999998},null,{"$f":"E19+E27+E37+E47+E57+E63+E73+E83+E92+E102+E111+E119","v":275.21999999999997},240.18999999999997,835.4639999999999,7936.200000000001,2023.29,3191.193,485.7610000000001]
[]
[null,"средняя величина за 1 день",{"$f":"C121/12","v":57.38416666666665},null,22.935,20.01583333333333,69.622,661.35,168.6075,265.93275,40.48008333333334]

{"sheet":"потребность","index":2,"n_rows":39,"n_cols":58,"rows_kept":39,"merged":[[0,0,0,25]]}
["КАЛЬКУЛЯЦИЯ БЛЮД"]
["наименование","Горбуша тушенная с овощами","хлеб пшеничный","хлеб дарницкий","чай с сахаром","салат из моркови с сахаром","котлеты рубленные из говядины","гуляш из говядины","каша гречневая рассыпчатая","чай с лимоном","кофейный напиток","сыр порционный","гуляш из птицы","груша","рис отварной","макароны       отварные","котлеты рубленные из птицы","картофельное       пюре","какао с молоком","плов из птицы","салат из свеклы отварной","пельмени отварные","салат из свежей капусты","жаркое из птицы","каша манная","булочка","тефтели мясные с рисом","сок фруктово-ягодный ","яблоко","апельсины","помидор","огурец","итого на 1 ребенка на 2 недели","всего на 16 недель","дж 1       225","дж 2    315","дж гимназия     247","сарман сош    205","каран 12","сарман гимназия 272","азалак 11","алекс 23","альмэт 55","большенуркей 32","юлтимер 4","карашай 12","илексаз 16","кавзияк 17","кутемели 7","лэке 3","леш-тамак 42","муртамак 9","петровка 57","ст.кашир 26","сарайлы 12","сакловбаш 18","ст.мензелябаш 15","шарли 9"]
["количество раз за 2 недели",2,11,10,4,2,1,1,2,5,1,0,1,2,2,2,2,2,2,1,2,1,2,1,1,1,1,3,4,3,1,1]
["лимон",{"$nulls":8},0.04,{"$nulls":22},{"$f":"SUM(B4:AF4)","v":0.04},{"$f":"AG4*8","v":0.32},{"$f":"AH4*225","v":72},{"$f":"AH4*315","v":100.8},{"$f":"AH4*247","v":79.04},{"$f":"AH4*205","v":65.6},{"$f":"AH4*12","v":3.84},{"$f":"AH4*272","v":87.04},{"$f":"AH4*11","v":3.52},{"$f":"AH4*23","v":7.36},{"$f":"AH4*55","v":17.6},{"$f":"AH4*32","v":10.24},{"$f":"AH4*4","v":1.28},{"$f":"AH4*12","v":3.84},{"$f":"AH4*16","v":5.12},{"$f":"AH4*17","v":5.44},{"$f":"AH4*7","v":2.24},{"$f":"AH4*3","v":0.96},{"$f":"AH4*42","v":13.44},{"$f":"AH4*9","v":2.88},{"$f":"AH4*57","v":18.240000000000002},{"$f":"AH4*26","v":8.32},{"$f":"AH4*12","v":3.84},{"$f":"AH4*18","v":5.76},{"$f":"AH4*15","v":4.8},{"$f":"AH4*9","v":2.88}]
["грудка ",{"$nulls":11},0.107,{"$nulls":3},0.18,null,null,0.09,{"$nulls":3},0.096,{"$nulls":8},0.473,{"$f":"AG5*8","v":3.784},{"$f":"AH5*225","v":851.4},{"$f":"AH5*315","v":1191.96},{"$f":"AH5*247","v":934.6479999999999},{"$f":"AH5*205","v":775.7199999999999},{"$f":"AH5*12","v":45.408},{"$f":"AH5*272","v":1029.248},{"$f":"AH5*11","v":41.623999999999995},{"$f":"AH5*23","v":87.032},{"$f":"AH5*55","v":208.11999999999998},{"$f":"AH5*32","v":121.088},{"$f":"AH5*4","v":15.136},{"$f":"AH5*12","v":45.408},{"$f":"AH5*16","v":60.544},{"$f":"AH5*17","v":64.328},{"$f":"AH5*7","v":26.488},{"$f":"AH5*3","v":11.352},{"$f":"AH5*42","v":158.928},{"$f":"AH5*9","v":34.056},{"$f":"AH5*57","v":215.688},{"$f":"AH5*26","v":98.384},{"$f":"AH5*12","v":45.408},{"$f":"AH5*18","v":68.112},{"$f":"AH5*15","v":56.76},{"$f":"AH5*9","v":34.056}]
["какао",{"$nulls":17},0.008,{"$nulls":13},0.008,0.064,14.4,20.16,15.808,13.120000000000001,0.768,17.408,0.704,1.472,3.52,2.048,0.256,0.768,1.024,1.088,0.448,0.192,2.688,0.5760000000000001,3.648,1.6640000000000001,0.768,1.1520000000000001,0.96,0.5760000000000001]
["капуста",{"$nulls":21},0.136,{"$nulls":9},0.136,1.088,244.8,342.72,268.73600000000005,223.04000000000002,13.056000000000001,295.93600000000004,11.968,25.024,59.84,34.816,4.352,13.056000000000001,17.408,18.496000000000002,7.6160000000000005,3.2640000000000002,45.696000000000005,9.792000000000002,62.016000000000005,28.288000000000004,13.056000000000001,19.584000000000003,16.32,9.792000000000002]
["картофель   ",{"$nulls":16},0.342,{"$nulls":5},0.106,{"$nulls":8},0.448,3.584,806.4,1128.96,885.248,734.72,43.008,974.8480000000001,39.424,82.432,197.12,114.688,14.336,43.008,57.344,60.928000000000004,25.088,10.752,150.528,32.256,204.288,93.184,43.008,64.512,53.76,32.256]
["кофейный напиток",{"$nulls":9},0.005,{"$nulls":21},0.005,0.04,9,12.6,9.88,8.2,0.48,10.88,0.44,0.92,2.2,1.28,0.16,0.48,0.64,0.68,0.28,0.12,1.68,0.36,2.2800000000000002,1.04,0.48,0.72,0.6,0.36]
["манная крупа",{"$nulls":23},0.03,{"$nulls":7},0.03,0.24,54,75.6,59.28,49.199999999999996,2.88,65.28,2.6399999999999997,5.52,13.2,7.68,0.96,2.88,3.84,4.08,1.68,0.72,10.08,2.16,13.68,6.24,2.88,4.32,3.5999999999999996,2.16]
["гречка ",{"$nulls":7},0.07,{"$nulls":23},0.07,0.56,126.00000000000001,176.4,138.32000000000002,114.80000000000001,6.720000000000001,152.32000000000002,6.16,12.88,30.800000000000004,17.92,2.24,6.720000000000001,8.96,9.520000000000001,3.9200000000000004,1.6800000000000002,23.520000000000003,5.040000000000001,31.92,14.560000000000002,6.720000000000001,10.080000000000002,8.4,5.040000000000001]
["сыр",{"$nulls":10},0.0209,{"$nulls":20},0.0209,0.1672,37.62,52.668,41.298399999999994,34.275999999999996,2.0063999999999997,45.47839999999999,1.8392,3.8455999999999997,9.196,5.3504,0.6688,2.0063999999999997,2.6752,2.8423999999999996,1.1703999999999999,0.5015999999999999,7.022399999999999,1.5048,9.530399999999998,4.3472,2.0063999999999997,3.0096,2.508,1.5048]
["груша",{"$nulls":12},0.24,{"$nulls":18},0.24,1.92,432,604.8,474.24,393.59999999999997,23.04,522.24,21.119999999999997,44.16,105.6,61.44,7.68,23.04,30.72,32.64,13.44,5.76,80.64,17.28,109.44,49.92,23.04,34.56,28.799999999999997,17.28]
["макароны ",{"$nulls":14},0.104,{"$nulls":16},0.104,0.832,187.2,262.08,205.504,170.56,9.984,226.304,9.152,19.136,45.76,26.624,3.328,9.984,13.312,14.144,5.824,2.496,34.943999999999996,7.4879999999999995,47.424,21.631999999999998,9.984,14.975999999999999,12.479999999999999,7.4879999999999995]
["лук",0.028,{"$nulls":4},0.007,0.018,{"$nulls":4},0.018,{"$nulls":6},0.011,{"$nulls":3},0.012,null,null,0.013,{"$nulls":5},0.107,0.856,192.6,269.64,211.432,175.48,10.272,232.832,9.416,19.688,47.08,27.392,3.424,10.272,13.696,14.552,5.992,2.568,35.952,7.704,48.792,22.256,10.272,15.408,12.84,7.704]
["горбуша или треска",0.246,{"$nulls":30},0.246,1.968,442.8,619.92,486.096,403.44,23.616,535.296,21.648,45.263999999999996,108.24,62.976,7.872,23.616,31.488,33.456,13.776,5.904,82.656,17.712,112.176,51.168,23.616,35.424,29.52,17.712]
["масло раст ",0.014,{"$nulls":4},0.003,0.005,{"$nulls":4},0.005,{"$nulls":6},0.005,0.004,null,0.003,0.004,null,null,2E-3,{"$nulls":5},0.04500000000000001,0.3600000000000001,81.00000000000003,113.40000000000003,88.92000000000003,73.80000000000003,4.320000000000001,97.92000000000003,3.960000000000001,8.280000000000003,19.800000000000004,11.520000000000003,1.4400000000000004,4.320000000000001,5.760000000000002,6.120000000000002,2.5200000000000005,1.0800000000000003,15.120000000000005,3.240000000000001,20.520000000000007,9.360000000000003,4.320000000000001,6.480000000000002,5.400000000000001,3.240000000000001]
["масло сливочное",{"$nulls":7},0.01,{"$nulls":5},0.01,0.01,0.006,0.01,{"$nulls":3},0.005,null,null,0.005,{"$nulls":7},0.055999999999999994,0.44799999999999995,100.79999999999998,141.11999999999998,110.65599999999999,91.83999999999999,5.3759999999999994,121.856,4.927999999999999,10.303999999999998,24.639999999999997,14.335999999999999,1.7919999999999998,5.3759999999999994,7.167999999999999,7.616,3.1359999999999997,1.3439999999999999,18.816,4.032,25.535999999999998,11.648,5.3759999999999994,8.064,6.719999999999999,4.032]
["морковь",0.064,{"$nulls":3},0.146,{"$nulls":13},0.016,null,null,0.026,{"$nulls":9},0.252,2.016,453.6,635.04,497.952,413.28000000000003,24.192,548.352,22.176000000000002,46.368,110.88,64.512,8.064,24.192,32.256,34.272,14.112,6.048,84.672,18.144,114.912,52.416,24.192,36.288,30.240000000000002,18.144]
["мука",{"$nulls":6},0.004,{"$nulls":4},0.004,{"$nulls":19},0.008,0.064,14.4,20.16,15.808,13.120000000000001,0.768,17.408,0.704,1.472,3.52,2.048,0.256,0.768,1.024,1.088,0.448,0.192,2.688,0.5760000000000001,3.648,1.6640000000000001,0.768,1.1520000000000001,0.96,0.5760000000000001]
["мясо",{"$nulls":5},0.075,0.107,{"$nulls":18},0.052,{"$nulls":5},0.23399999999999999,1.8719999999999999,421.2,589.68,462.38399999999996,383.76,22.464,509.18399999999997,20.592,43.056,102.96,59.903999999999996,7.4879999999999995,22.464,29.951999999999998,31.823999999999998,13.104,5.616,78.624,16.848,106.704,48.672,22.464,33.696,28.08,16.848]
["пельмени",{"$nulls":20},0.14,{"$nulls":10},0.14,1.12,252.00000000000003,352.8,276.64000000000004,229.60000000000002,13.440000000000001,304.64000000000004,12.32,25.76,61.60000000000001,35.84,4.48,13.440000000000001,17.92,19.040000000000003,7.840000000000001,3.3600000000000003,47.040000000000006,10.080000000000002,63.84,29.120000000000005,13.440000000000001,20.160000000000004,16.8,10.080000000000002]
["рис",{"$nulls":13},0.108,{"$nulls":4},0.057,{"$nulls":6},0.005,{"$nulls":5},0.17,1.36,306,428.40000000000003,335.92,278.8,16.32,369.92,14.96,31.28,74.80000000000001,43.52,5.44,16.32,21.76,23.12,9.520000000000001,4.08,57.120000000000005,12.24,77.52000000000001,35.36,16.32,24.48,20.400000000000002,12.24]
["сахар",{"$nulls":3},0.06,2E-3,{"$nulls":3},0.075,0.02,{"$nulls":7},0.04,{"$nulls":3},0.004,null,0.003,{"$nulls":7},0.20400000000000001,1.6320000000000001,367.20000000000005,514.08,403.10400000000004,334.56,19.584000000000003,443.90400000000005,17.952,37.536,89.76,52.224000000000004,6.5280000000000005,19.584000000000003,26.112000000000002,27.744000000000003,11.424000000000001,4.896000000000001,68.54400000000001,14.688,93.024,42.432,19.584000000000003,29.376,24.48,14.688]
["рыба минтай",{"$nulls":31},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["свекла",{"$nulls":19},0.146,{"$nulls":11},0.146,1.168,262.8,367.91999999999996,288.496,239.44,14.015999999999998,317.69599999999997,12.847999999999999,26.863999999999997,64.24,37.376,4.672,14.015999999999998,18.688,19.855999999999998,8.176,3.5039999999999996,49.056,10.511999999999999,66.576,30.368,14.015999999999998,21.023999999999997,17.52,10.511999999999999]
["молоко",{"$nulls":5},0.015,{"$nulls":3},0.1,{"$nulls":5},0.036,0.046,0.2,{"$nulls":5},0.1,{"$nulls":7},0.497,3.976,894.6,1252.44,982.072,815.08,47.712,1081.472,43.736,91.448,218.68,127.232,15.904,47.712,63.616,67.592,27.832,11.928,166.992,35.784,226.632,103.376,47.712,71.568,59.64,35.784]
["булочка ",{"$nulls":24},1,{"$nulls":6},1,8,1800,2520,1976,1640,96,2176,88,184,440,256,32,96,128,136,56,24,336,72,456,208,96,144,120,72]
["соль",2E-3,{"$nulls":4},1E-3,2E-3,2E-3,{"$nulls":3},1E-3,null,2E-3,2E-3,2E-3,2E-3,null,1E-3,null,1E-3,2E-3,1E-3,1E-3,null,1E-3,{"$nulls":5},0.023000000000000007,0.18400000000000005,41.40000000000001,57.960000000000015,45.448000000000015,37.72000000000001,2.2080000000000006,50.048000000000016,2.0240000000000005,4.232000000000001,10.120000000000003,5.888000000000002,0.7360000000000002,2.2080000000000006,2.944000000000001,3.128000000000001,1.2880000000000003,0.5520000000000002,7.728000000000002,1.6560000000000006,10.488000000000003,4.784000000000002,2.2080000000000006,3.312000000000001,2.7600000000000007,1.6560000000000006]
["яблоки  свежие",{"$nulls":27},0.6,{"$nulls":3},0.6,4.8,1080,1512,1185.6,984,57.599999999999994,1305.6,52.8,110.39999999999999,264,153.6,19.2,57.599999999999994,76.8,81.6,33.6,14.399999999999999,201.6,43.199999999999996,273.59999999999997,124.8,57.599999999999994,86.39999999999999,72,43.199999999999996]
[{"$nulls":32},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["хлеб дарницкий(кг)",null,null,0.25,{"$nulls":28},0.25,2,450,630,494,410,24,544,22,46,110,64,8,24,32,34,14,6,84,18,114,52,24,36,30,18]
["томат паста",{"$nulls":6},0.012,{"$nulls":4},0.012,{"$nulls":6},0.005,{"$nulls":12},0.029,0.232,52.2,73.08,57.304,47.56,2.7840000000000003,63.104000000000006,2.552,5.336,12.76,7.424,0.928,2.7840000000000003,3.712,3.9440000000000004,1.624,0.6960000000000001,9.744,2.088,13.224,6.032,2.7840000000000003,4.176,3.48,2.088]
["сок",{"$nulls":26},0.6,{"$nulls":4},0.6,4.8,1080,1512,1185.6,984,57.599999999999994,1305.6,52.8,110.39999999999999,264,153.6,19.2,57.599999999999994,76.8,81.6,33.6,14.399999999999999,201.6,43.199999999999996,273.59999999999997,124.8,57.599999999999994,86.39999999999999,72,43.199999999999996]
["хлеб в/с(кг)",null,0.55,{"$nulls":29},0.55,4.4,990.0000000000001,1386,1086.8000000000002,902.0000000000001,52.800000000000004,1196.8000000000002,48.400000000000006,101.2,242.00000000000003,140.8,17.6,52.800000000000004,70.4,74.80000000000001,30.800000000000004,13.200000000000001,184.8,39.6,250.8,114.4,52.800000000000004,79.2,66,39.6]
["чай  ",{"$nulls":3},0.004,{"$nulls":4},0.01,{"$nulls":22},0.014,0.112,25.2,35.28,27.664,22.96,1.344,30.464000000000002,1.232,2.576,6.16,3.584,0.448,1.344,1.792,1.9040000000000001,0.784,0.336,4.704,1.008,6.384,2.912,1.344,2.016,1.68,1.008]
["апельсины",{"$nulls":28},0.45,null,null,0.45,3.6,810,1134,889.2,738,43.2,979.2,39.6,82.8,198,115.2,14.4,43.2,57.6,61.2,25.2,10.8,151.20000000000002,32.4,205.20000000000002,93.60000000000001,43.2,64.8,54,32.4]
["помидор",{"$nulls":29},0.07,null,0.07,0.56,126.00000000000001,176.4,138.32000000000002,114.80000000000001,6.720000000000001,152.32000000000002,6.16,12.88,30.800000000000004,17.92,2.24,6.720000000000001,8.96,9.520000000000001,3.9200000000000004,1.6800000000000002,23.520000000000003,5.040000000000001,31.92,14.560000000000002,6.720000000000001,10.080000000000002,8.4,5.040000000000001]
["огурец",{"$nulls":30},0.063,{"$f":"AF39","v":0.063},0.504,113.4,158.76,124.488,103.32000000000001,6.048,137.088,5.5440000000000005,11.592,27.72,16.128,2.016,6.048,8.064,8.568,3.528,1.512,21.168,4.536,28.728,13.104,6.048,9.072,7.5600000000000005,4.536]

{"sheet":"Лист1","index":3,"n_rows":6,"n_cols":38,"rows_kept":6,"merged":[[0,0,0,11]]}
["КАЛЬКУЛЯЦИЯ БЛЮД"]
["наименование","котлеты рубленные из говядины","каша гречневая рассыпчатая","кофейный напиток","сыр порционный","рис отварной","макароны       отварные","котлеты рубленные из птицы","картофельное       пюре","какао с молоком","пельмени отварные","каша манная","итого на 1 ребенка на 2 недели","всего на 32 недель(год)","дж 1       225","дж 2    315","дж гимназия     247","сарман сош    205","каран 12","сарман гимназия 272","азалак 11","алекс 23","альмэт 55","большенуркей 32","юлтимер 4","карашай 12","илексаз 16","кавзияк 17","кутемели 7","лэке 3","леш-тамак 42","муртамак 9","петровка 57","ст.кашир 26","сарайлы 12","сакловбаш 18","ст.мензелябаш 15","шарли 9"]
["количество раз за 2 недели",1,2,1,1,2,2,2,2,2,1,1]
["масло сливочное",null,0.01,null,null,0.01,0.01,0.006,0.01,null,0.005,0.005,{"$f":"SUM(B4:L4)","v":0.055999999999999994},{"$f":"M4*16","v":0.8959999999999999},{"$f":"N4*225","v":201.59999999999997},{"$f":"N4*315","v":282.23999999999995},{"$f":"N4*247","v":221.31199999999998},{"$f":"N4*205","v":183.67999999999998},{"$f":"N4*12","v":10.751999999999999},{"$f":"N4*272","v":243.712},{"$f":"N4*11","v":9.855999999999998},{"$f":"N4*23","v":20.607999999999997},{"$f":"N4*55","v":49.279999999999994},{"$f":"N4*32","v":28.671999999999997},{"$f":"N4*4","v":3.5839999999999996},{"$f":"N4*12","v":10.751999999999999},{"$f":"N4*16","v":14.335999999999999},{"$f":"N4*17","v":15.232},{"$f":"N4*7","v":6.271999999999999},{"$f":"N4*3","v":2.6879999999999997},{"$f":"N4*42","v":37.632},{"$f":"N4*9","v":8.064},{"$f":"N4*57","v":51.071999999999996},{"$f":"N4*26","v":23.296},{"$f":"N4*12","v":10.751999999999999},{"$f":"N4*18","v":16.128},{"$f":"N4*15","v":13.439999999999998},{"$f":"N4*9","v":8.064}]
["молоко",0.015,null,0.1,{"$nulls":3},0.022,0.046,0.2,null,0.1,{"$f":"SUM(B5:L5)","v":0.483},{"$f":"M5*16","v":7.728},1738.8,2434.3199999999997,1908.816,1584.24,92.73599999999999,2102.016,85.008,177.744,425.03999999999996,247.296,30.912,92.73599999999999,123.648,131.376,54.096,23.183999999999997,324.57599999999996,69.55199999999999,440.496,200.928,92.73599999999999,139.10399999999998,115.92,69.55199999999999]
["сыр порционный",{"$nulls":3},0.0209,{"$nulls":7},{"$f":"SUM(B6:L6)","v":0.0209},0.3344,75.24,105.336,82.59679999999999,68.55199999999999,4.0127999999999995,90.95679999999999,3.6784,7.691199999999999,18.392,10.7008,1.3376,4.0127999999999995,5.3504,5.684799999999999,2.3407999999999998,1.0031999999999999,14.044799999999999,3.0096,19.060799999999997,8.6944,4.0127999999999995,6.0192,5.016,3.0096]